﻿<ViewDataFormTemplateSpec 
	xmlns="bb_appfx_viewdataformtemplate" 
	xmlns:common="bb_appfx_commontypes" 
	ID="65a7b4bf-de90-4157-9d22-5e30c67f0117" 
	Name="Address GUID View Form"
	Description="Get the GUID of an address record from the custom ID"
	Author="Blackbaud Professional Services"
	DataFormInstanceID="21428c12-30ba-42f4-80e7-9664a5eab682" 
	RecordType="Address"
  common:SecurityUIFolder="Service Bus Adapter"
	>

	<!-- define the SP that returns the data used by the form -->
	<SPDataForm SPName="USR_USP_DATAFORMTEMPLATE_VIEW_ADDRESS_GET_GUID">
		<common:CreateProcedureSQL>
			<![CDATA[
create procedure dbo.USR_USP_DATAFORMTEMPLATE_VIEW_ADDRESS_GET_GUID
(
	@ID nvarchar(255),
	@DATALOADED bit = 0 output,
	@ADDRESSID uniqueidentifier = null output
)
as
	set nocount on;
	
	-- be sure to set this, in case the select returns no rows
	set @DATALOADED = 0;
	
	-- populate the output parameters, which correspond to fields on the form.  Note that
	-- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system
	-- will display a "no data loaded" message.
	select 
    @DATALOADED = 1,
		@ADDRESSID = a.ID
	from 
    dbo.ADDRESS a
    inner join dbo.USR_ADDRESS ua on a.ID = ua.ID
	where 
    ua.LOOKUPID = @ID 
	
	return 0;
			]]>
		</common:CreateProcedureSQL>
	</SPDataForm>

	<!-- describe fields on the form, which correspond to parameters on the SP.  Note that system paramters 
	like the context @ID, @DATALOADED, and @CURRENTAPPUSERID need not be listed. -->
	<common:FormMetaData FixedDialog="true">
		<common:FormFields>
			<common:FormField FieldID="ADDRESSID" Caption="Address ID" DataType="Guid" />
		</common:FormFields>
	</common:FormMetaData>

</ViewDataFormTemplateSpec>